<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %><%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2018/4/2
  Time: 19:56
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%--<%--%>
    <%--//未登录--%>
    <%--if (session.getAttribute("username")==null){--%>
        <%--//跳转--%>
        <%--response.sendRedirect("login.jsp");--%>
    <%--}--%>
<%--%>--%>
<style type="text/css">
    table{
        border-collapse: collapse;
    }
    td{
        border: 1px solid #000;
        padding: 10px;
    }

</style>

<%--<h1>用户管理系统</h1>--%>
<%--<a href="userAdd.jsp">添加地址</a>--%>
<jsp:include page="header.jsp"></jsp:include>

<table>
    <tr>
        <td>编号</td>
        <td>姓名</td>  <%--ctrl+d--%>
        <td>密码</td><%--ctrl+w--%>
        <td>操作1</td>
        <td>操作2</td>
    </tr>
    <%
        class User{
            int id;
            String name;
            String password;
        }
        List<User>userList=new ArrayList<User>();

//        User chen=new User();
//        chen.id=1;
//        chen.name="xhenggongshuo";
//        chen.password="123";
//       userList.add(chen);

        Connection connection=null;
        Statement statement=null;
        ResultSet resultSet=null;

        String sql="select * from t_users";

        Class.forName("com.mysql.jdbc.Driver");
        connection= DriverManager.getConnection(
                "jdbc:mysql://47.104.80.155:3306/javaweb",
                "javaweb",
                "JAVAweb123!@#"
        );

        statement=connection.createStatement();
        resultSet=statement.executeQuery(sql);

        while(resultSet.next()){
            int id=resultSet.getInt(1);
            String name=resultSet.getString(2);
            String password=resultSet.getString(3);

            User user=new User();
            user.id=id;
            user.name=name;
            user.password=password;
            userList.add(user);
        }
        resultSet.close();
        statement.close();
        connection.close();

        for(User user:userList){
            out.write("<tr>" +
                    "<td>"+user.id+"</td>" +
                    "<td>"+user.name+"</td>" +
                    "<td>"+user.password+"</td>" +
                    "<td><a href='deleteUserHandler.jsp?id="+user.id+"'>删除</a></td>" +
                    "<td><a href='userUpdata.jsp?id="+user.id+"&username="+user.name+"&password="+user.password+"'>更新</a></td>" +
                    "</tr>");
        }
    %>
    <%--<tr><td>1</td><td>John</td><td>123</td></tr>--%>
</table>
<%@include file="footer.jsp"%>
</body>
</html>
